Dashboard 03 - ZipCode - Creating Line and Clustered Column charts Visualizations - Part 01 17



In this step, we will create a map and charts in the 3rd dashboard / page.



Step 1:  Create Line and Clustered Column Chart for AVG Year Over Year (YOY) Apartment & House Prices/Sq. Ft. by Property  (Description) Desc



In Power BI Desktop, click on the page, ZipCode

If selected, de-select a visualization by clicking an empty area of the report page.


Visualizations

Click the Line and Clustered Column Chart icon

Fields

Select the following:

Under Visualizations, drag & drop it in the Shared Axis section:
Type_and_Use ->  Type_Use_Description
DateDimension[Date] ->  Year



Under Visualizations, drag & drop it in the Column Values section:
A_KeyMeasures -> .AVG_ResidentialPrice_PerSqFt%


Under Visualizations, drag & drop it in the Line Values section:
A_KeyMeasures ->  .YOY_AVG_ResidentialPrice_PerSqFt%


Under Visualizations, drag & drop it in the Tooltips section:

A_KeyMeasures ->  .YOY_Diff_AVG_ResidentialPrice_PerSqFt%
A_KeyMeasures ->  .AVG_Residential_Prices




Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

Type_Use_Description = Property Type Description
.AVG_ResidentialPrice_PerSqFt% = AVG House Price/Sq. Ft.
.YOY_AVG_ResidentialPrice_PerSqFt% = YOY AVG House Price/Sq. Ft.
.YOY_Diff_AVG_ResidentialPrice_PerSqFt% = YOY AVG House Price/Sq. Ft.
.AVG_Residential_Prices = AVG House Price







Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.



Under Format ->  General: X Position = 924 , Y Position = 171 , Width = 576 , Height = 428

Under Format -> Legend ->  Set it to ON , Position = Top Center , Title = OFF , Color = #000000 , Legend Name = [blank] , Font Family = Segoe UI , Text Size = 13 pt , Style = Markers Only

Under Format -> X Axis -> Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Start = Auto ,  Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Gridlines = ON , Line Color = #000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = #5B8F22 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors ->

YOY AVG Hse Price/Sq. Ft. = #925231

Default Color = #DC8250


Under Format ->  Data Labels ->  Set it to ON , Color = #000000 , Display Units = Auto , Value Decimal Places = 0 , Text Size = 14 pt , Font Family = Segoe UI , Show Background = Off ,

Customize Series  = ON ,

(Select AVG Hse Price/Sq. Ft.  -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)

(Select YOY AVG Hse Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Average & YOY House Price/Sq. Ft. by Property Desc , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to OFF



Step 2 - Configure Filter(s)

Filters

None.







When finished, save project.





Tips and Tricks for Maps in Power BI